Pandas Profiling Report

Dataset statistics

Number of variables	23
Number of observations	5399
Missing cells	361
Missing cells (%)	0.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	2.8 MiB
Average record size in memory	542.4 B

Variable types

Numeric	16
Boolean	7

Alerts

`potential_issue` has constant value "False"	Constant
`oe_constraint` has constant value "False"	Constant
`national_inv` is highly correlated with `sales_9_month`	High correlation
`in_transit_qty` is highly correlated with `forecast_3_month` and 7 other fields	High correlation
`forecast_3_month` is highly correlated with `in_transit_qty` and 7 other fields	High correlation
`forecast_6_month` is highly correlated with `in_transit_qty` and 8 other fields	High correlation
`forecast_9_month` is highly correlated with `in_transit_qty` and 7 other fields	High correlation
`sales_1_month` is highly correlated with `in_transit_qty` and 7 other fields	High correlation
`sales_3_month` is highly correlated with `in_transit_qty` and 7 other fields	High correlation
`sales_6_month` is highly correlated with `in_transit_qty` and 7 other fields	High correlation
`sales_9_month` is highly correlated with `national_inv` and 8 other fields	High correlation
`min_bank` is highly correlated with `in_transit_qty` and 7 other fields	High correlation
`perf_6_month_avg` is highly correlated with `perf_12_month_avg`	High correlation
`perf_12_month_avg` is highly correlated with `perf_6_month_avg`	High correlation
`pieces_past_due` is highly correlated with `forecast_6_month` and 1 other fields	High correlation
`local_bo_qty` is highly correlated with `pieces_past_due`	High correlation
`stop_auto_buy` is highly correlated with `lead_time`	High correlation
`went_on_backorder` is highly correlated with `potential_issue` and 1 other fields	High correlation
`deck_risk` is highly correlated with `lead_time`	High correlation
`ppap_risk` is highly correlated with `potential_issue` and 1 other fields	High correlation
`potential_issue` is highly correlated with `stop_auto_buy` and 5 other fields	High correlation
`oe_constraint` is highly correlated with `stop_auto_buy` and 5 other fields	High correlation
`rev_stop` is highly correlated with `potential_issue` and 1 other fields	High correlation
`lead_time` is highly correlated with `deck_risk` and 1 other fields	High correlation
`lead_time` has 361 (6.7%) missing values	Missing
`national_inv` is highly skewed (γ1 = 31.33974204)	Skewed
`in_transit_qty` is highly skewed (γ1 = 52.37164737)	Skewed
`forecast_6_month` is highly skewed (γ1 = 22.1929959)	Skewed
`forecast_9_month` is highly skewed (γ1 = 23.76410595)	Skewed
`sales_1_month` is highly skewed (γ1 = 20.43889742)	Skewed
`sales_3_month` is highly skewed (γ1 = 20.29849041)	Skewed
`sales_6_month` is highly skewed (γ1 = 22.33594794)	Skewed
`sales_9_month` is highly skewed (γ1 = 21.00267975)	Skewed
`min_bank` is highly skewed (γ1 = 27.18121113)	Skewed
`pieces_past_due` is highly skewed (γ1 = 40.59990285)	Skewed
`local_bo_qty` is highly skewed (γ1 = 59.13402525)	Skewed
`sku` has unique values	Unique
`national_inv` has 375 (6.9%) zeros	Zeros
`in_transit_qty` has 4409 (81.7%) zeros	Zeros
`forecast_3_month` has 3861 (71.5%) zeros	Zeros
`forecast_6_month` has 3548 (65.7%) zeros	Zeros
`forecast_9_month` has 3382 (62.6%) zeros	Zeros
`sales_1_month` has 3140 (58.2%) zeros	Zeros
`sales_3_month` has 2521 (46.7%) zeros	Zeros
`sales_6_month` has 2192 (40.6%) zeros	Zeros
`sales_9_month` has 1987 (36.8%) zeros	Zeros
`min_bank` has 2880 (53.3%) zeros	Zeros
`pieces_past_due` has 5340 (98.9%) zeros	Zeros
`perf_6_month_avg` has 128 (2.4%) zeros	Zeros
`perf_12_month_avg` has 87 (1.6%) zeros	Zeros
`local_bo_qty` has 5323 (98.6%) zeros	Zeros

Reproduction

Analysis started	2022-09-30 07:41:50.654791
Analysis finished	2022-09-30 07:42:33.094227
Duration	42.44 seconds
Software version	pandas-profiling v3.3.1
Download configuration	config.json

sku
Real number (ℝ_≥0)

UNIQUE

Distinct	5399
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1114130.429

Minimum	1026827
Maximum	1237426
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	42.3 KiB

Quantile statistics

Minimum	1026827
5-th percentile	1111788.9
Q1	1112868.5
median	1114218
Q3	1115567.5
95-th percentile	1116647.1
Maximum	1237426
Range	210599
Interquartile range (IQR)	2699

Descriptive statistics

Standard deviation	8962.790253
Coefficient of variation (CV)	0.008044650806
Kurtosis	86.27023799
Mean	1114130.429
Median Absolute Deviation (MAD)	1350
Skewness	3.017674098
Sum	6015190186
Variance	80331609.12
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1026827	1	< 0.1%
1115077	1	< 0.1%
1115085	1	< 0.1%
1115084	1	< 0.1%
1115083	1	< 0.1%
1115082	1	< 0.1%
1115081	1	< 0.1%
1115080	1	< 0.1%
1115079	1	< 0.1%
1115078	1	< 0.1%
Other values (5389)	5389	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1026827	1	< 0.1%
1043384	1	< 0.1%
1043696	1	< 0.1%
1043852	1	< 0.1%
1044048	1	< 0.1%
1044198	1	< 0.1%
1044643	1	< 0.1%
1045098	1	< 0.1%
1045815	1	< 0.1%
1045867	1	< 0.1%

Value	Count	Frequency (%)
1237426	1	< 0.1%
1236537	1	< 0.1%
1235137	1	< 0.1%
1226726	1	< 0.1%
1225137	1	< 0.1%
1221415	1	< 0.1%
1220808	1	< 0.1%
1219165	1	< 0.1%
1218575	1	< 0.1%
1218378	1	< 0.1%

national_inv
Real number (ℝ)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	776
Distinct (%)	14.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	311.4076681

Minimum	-1186
Maximum	129280
Zeros	375
Zeros (%)	6.9%
Negative	21
Negative (%)	0.4%
Memory size	42.3 KiB

Quantile statistics

Minimum	-1186
5-th percentile	0
Q1	4
median	14
Q3	72
95-th percentile	893.4
Maximum	129280
Range	130466
Interquartile range (IQR)	68

Descriptive statistics

Standard deviation	2487.163691
Coefficient of variation (CV)	7.986841514
Kurtosis	1415.158317
Mean	311.4076681
Median Absolute Deviation (MAD)	12
Skewness	31.33974204
Sum	1681290
Variance	6185983.226
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	375	6.9%
2	332	6.1%
3	286	5.3%
5	213	3.9%
4	205	3.8%
1	182	3.4%
10	157	2.9%
8	142	2.6%
6	135	2.5%
9	131	2.4%
Other values (766)	3241	60.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-1186	1	< 0.1%
-499	1	< 0.1%
-94	1	< 0.1%
-58	1	< 0.1%
-55	1	< 0.1%
-54	1	< 0.1%
-48	1	< 0.1%
-35	1	< 0.1%
-34	1	< 0.1%
-29	1	< 0.1%

Value	Count	Frequency (%)
129280	1	< 0.1%
44286	1	< 0.1%
41673	1	< 0.1%
40320	1	< 0.1%
37657	1	< 0.1%
35612	1	< 0.1%
35496	1	< 0.1%
27171	1	< 0.1%
23452	1	< 0.1%
19906	1	< 0.1%

lead_time
Real number (ℝ_≥0)

HIGH CORRELATION
MISSING

Distinct	24
Distinct (%)	0.5%
Missing	361
Missing (%)	6.7%
Infinite	0
Infinite (%)	0.0%
Mean	7.844382692

Minimum	0
Maximum	52
Zeros	25
Zeros (%)	0.5%
Negative	0
Negative (%)	0.0%
Memory size	42.3 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	4
median	8
Q3	8
95-th percentile	12
Maximum	52
Range	52
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	6.896811635
Coefficient of variation (CV)	0.8792038719
Kurtosis	27.38105868
Mean	7.844382692
Median Absolute Deviation (MAD)	1
Skewness	4.632144674
Sum	39520
Variance	47.56601073
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
8	2224	41.2%
2	1041	19.3%
12	608	11.3%
4	415	7.7%
9	384	7.1%
52	90	1.7%
3	59	1.1%
10	56	1.0%
14	35	0.6%
16	25	0.5%
Other values (14)	101	1.9%
(Missing)	361	6.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	25	0.5%
2	1041	19.3%
3	59	1.1%
4	415	7.7%
5	13	0.2%
6	18	0.3%
7	1	< 0.1%
8	2224	41.2%
9	384	7.1%
10	56	1.0%

Value	Count	Frequency (%)
52	90	1.7%
40	1	< 0.1%
30	2	< 0.1%
26	1	< 0.1%
22	2	< 0.1%
21	1	< 0.1%
20	3	0.1%
17	10	0.2%
16	25	0.5%
15	8	0.1%

in_transit_qty
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	238
Distinct (%)	4.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	28.01741063

Minimum	0
Maximum	27430
Zeros	4409
Zeros (%)	81.7%
Negative	0
Negative (%)	0.0%
Memory size	42.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	51
Maximum	27430
Range	27430
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	422.2830546
Coefficient of variation (CV)	15.07216567
Kurtosis	3302.60745
Mean	28.01741063
Median Absolute Deviation (MAD)	0
Skewness	52.37164737
Sum	151266
Variance	178322.9782
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4409	81.7%
1	121	2.2%
2	68	1.3%
3	57	1.1%
4	45	0.8%
5	38	0.7%
6	38	0.7%
10	28	0.5%
12	22	0.4%
8	21	0.4%
Other values (228)	552	10.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4409	81.7%
1	121	2.2%
2	68	1.3%
3	57	1.1%
4	45	0.8%
5	38	0.7%
6	38	0.7%
7	21	0.4%
8	21	0.4%
9	20	0.4%

Value	Count	Frequency (%)
27430	1	< 0.1%
6000	1	< 0.1%
5136	1	< 0.1%
3840	1	< 0.1%
3500	1	< 0.1%
3417	1	< 0.1%
3000	2	< 0.1%
2920	1	< 0.1%
2730	1	< 0.1%
2652	1	< 0.1%

forecast_3_month
Real number (ℝ_≥0)

HIGH CORRELATION
ZEROS

Distinct	383
Distinct (%)	7.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	92.21892943

Minimum	0
Maximum	20000
Zeros	3861
Zeros (%)	71.5%
Negative	0
Negative (%)	0.0%
Memory size	42.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	2
95-th percentile	240.5
Maximum	20000
Range	20000
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	732.1334813
Coefficient of variation (CV)	7.93908025
Kurtosis	376.4008846
Mean	92.21892943
Median Absolute Deviation (MAD)	0
Skewness	17.33825262
Sum	497890
Variance	536019.4345
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3861	71.5%
2	101	1.9%
1	88	1.6%
5	66	1.2%
10	59	1.1%
4	59	1.1%
3	50	0.9%
6	44	0.8%
20	30	0.6%
8	29	0.5%
Other values (373)	1012	18.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3861	71.5%
1	88	1.6%
2	101	1.9%
3	50	0.9%
4	59	1.1%
5	66	1.2%
6	44	0.8%
7	24	0.4%
8	29	0.5%
9	12	0.2%

Value	Count	Frequency (%)
20000	1	< 0.1%
19800	1	< 0.1%
18660	1	< 0.1%
15000	1	< 0.1%
14400	1	< 0.1%
11328	1	< 0.1%
10800	1	< 0.1%
9532	1	< 0.1%
9480	1	< 0.1%
8692	1	< 0.1%

forecast_6_month
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	498
Distinct (%)	9.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	186.8697907

Minimum	0
Maximum	65484
Zeros	3548
Zeros (%)	65.7%
Negative	0
Negative (%)	0.0%
Memory size	42.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	8
95-th percentile	500
Maximum	65484
Range	65484
Interquartile range (IQR)	8

Descriptive statistics

Standard deviation	1564.630997
Coefficient of variation (CV)	8.372840743
Kurtosis	700.8567086
Mean	186.8697907
Median Absolute Deviation (MAD)	0
Skewness	22.1929959
Sum	1008910
Variance	2448070.157
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3548	65.7%
1	92	1.7%
2	92	1.7%
4	71	1.3%
5	60	1.1%
10	59	1.1%
3	58	1.1%
8	49	0.9%
6	43	0.8%
7	42	0.8%
Other values (488)	1285	23.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3548	65.7%
1	92	1.7%
2	92	1.7%
3	58	1.1%
4	71	1.3%
5	60	1.1%
6	43	0.8%
7	42	0.8%
8	49	0.9%
9	13	0.2%

Value	Count	Frequency (%)
65484	1	< 0.1%
33480	1	< 0.1%
30000	2	< 0.1%
27000	1	< 0.1%
26000	1	< 0.1%
21216	1	< 0.1%
19158	1	< 0.1%
17604	1	< 0.1%
16292	1	< 0.1%
15660	1	< 0.1%

forecast_9_month
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	577
Distinct (%)	10.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	276.241341

Minimum	0
Maximum	102252
Zeros	3382
Zeros (%)	62.6%
Negative	0
Negative (%)	0.0%
Memory size	42.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	14
95-th percentile	740.5
Maximum	102252
Range	102252
Interquartile range (IQR)	14

Descriptive statistics

Standard deviation	2295.900244
Coefficient of variation (CV)	8.311211624
Kurtosis	833.115744
Mean	276.241341
Median Absolute Deviation (MAD)	0
Skewness	23.76410595
Sum	1491427
Variance	5271157.932
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3382	62.6%
2	98	1.8%
1	92	1.7%
4	68	1.3%
3	61	1.1%
10	58	1.1%
5	56	1.0%
6	48	0.9%
7	44	0.8%
8	41	0.8%
Other values (567)	1451	26.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3382	62.6%
1	92	1.7%
2	98	1.8%
3	61	1.1%
4	68	1.3%
5	56	1.0%
6	48	0.9%
7	44	0.8%
8	41	0.8%
9	25	0.5%

Value	Count	Frequency (%)
102252	1	< 0.1%
47880	1	< 0.1%
43200	1	< 0.1%
40000	1	< 0.1%
38000	1	< 0.1%
30144	1	< 0.1%
27564	1	< 0.1%
27000	1	< 0.1%
26964	1	< 0.1%
24042	1	< 0.1%

sales_1_month
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	292
Distinct (%)	5.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	31.62900537

Minimum	0
Maximum	9608
Zeros	3140
Zeros (%)	58.2%
Negative	0
Negative (%)	0.0%
Memory size	42.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	4
95-th percentile	86
Maximum	9608
Range	9608
Interquartile range (IQR)	4

Descriptive statistics

Standard deviation	239.5093818
Coefficient of variation (CV)	7.572460119
Kurtosis	604.3847259
Mean	31.62900537
Median Absolute Deviation (MAD)	0
Skewness	20.43889742
Sum	170765
Variance	57364.74396
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	3140	58.2%
1	486	9.0%
2	257	4.8%
3	149	2.8%
4	120	2.2%
5	82	1.5%
7	78	1.4%
6	67	1.2%
8	57	1.1%
10	44	0.8%
Other values (282)	919	17.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	3140	58.2%
1	486	9.0%
2	257	4.8%
3	149	2.8%
4	120	2.2%
5	82	1.5%
6	67	1.2%
7	78	1.4%
8	57	1.1%
9	34	0.6%

Value	Count	Frequency (%)
9608	1	< 0.1%
5047	1	< 0.1%
4568	1	< 0.1%
4372	1	< 0.1%
4070	1	< 0.1%
3772	1	< 0.1%
3200	1	< 0.1%
3041	1	< 0.1%
2744	1	< 0.1%
2630	1	< 0.1%

sales_3_month
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	470
Distinct (%)	8.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	98.50879793

Minimum	0
Maximum	29327
Zeros	2521
Zeros (%)	46.7%
Negative	0
Negative (%)	0.0%
Memory size	42.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	1
Q3	12
95-th percentile	283.3
Maximum	29327
Range	29327
Interquartile range (IQR)	12

Descriptive statistics

Standard deviation	753.3293783
Coefficient of variation (CV)	7.64733094
Kurtosis	576.9960854
Mean	98.50879793
Median Absolute Deviation (MAD)	1
Skewness	20.29849041
Sum	531849
Variance	567505.1522
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2521	46.7%
1	427	7.9%
2	291	5.4%
3	169	3.1%
4	149	2.8%
5	109	2.0%
6	90	1.7%
7	76	1.4%
8	60	1.1%
10	57	1.1%
Other values (460)	1450	26.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2521	46.7%
1	427	7.9%
2	291	5.4%
3	169	3.1%
4	149	2.8%
5	109	2.0%
6	90	1.7%
7	76	1.4%
8	60	1.1%
9	48	0.9%

Value	Count	Frequency (%)
29327	1	< 0.1%
16625	1	< 0.1%
15180	1	< 0.1%
14960	1	< 0.1%
12921	1	< 0.1%
12576	1	< 0.1%
12494	1	< 0.1%
8364	1	< 0.1%
8244	1	< 0.1%
7423	1	< 0.1%

sales_6_month
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	612
Distinct (%)	11.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	197.5065753

Minimum	0
Maximum	65994
Zeros	2192
Zeros (%)	40.6%
Negative	0
Negative (%)	0.0%
Memory size	42.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	2
Q3	24
95-th percentile	548.4
Maximum	65994
Range	65994
Interquartile range (IQR)	24

Descriptive statistics

Standard deviation	1565.089201
Coefficient of variation (CV)	7.924238467
Kurtosis	717.2056926
Mean	197.5065753
Median Absolute Deviation (MAD)	2
Skewness	22.33594794
Sum	1066338
Variance	2449504.208
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2192	40.6%
1	395	7.3%
2	248	4.6%
3	162	3.0%
4	149	2.8%
5	115	2.1%
6	94	1.7%
7	76	1.4%
9	66	1.2%
8	64	1.2%
Other values (602)	1838	34.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2192	40.6%
1	395	7.3%
2	248	4.6%
3	162	3.0%
4	149	2.8%
5	115	2.1%
6	94	1.7%
7	76	1.4%
8	64	1.2%
9	66	1.2%

Value	Count	Frequency (%)
65994	1	< 0.1%
36510	1	< 0.1%
29785	1	< 0.1%
26620	1	< 0.1%
24591	1	< 0.1%
24517	1	< 0.1%
23756	1	< 0.1%
18725	1	< 0.1%
16571	1	< 0.1%
15972	1	< 0.1%

sales_9_month
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	723
Distinct (%)	13.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	308.6140026

Minimum	0
Maximum	98664
Zeros	1987
Zeros (%)	36.8%
Negative	0
Negative (%)	0.0%
Memory size	42.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	3
Q3	38
95-th percentile	833.2
Maximum	98664
Range	98664
Interquartile range (IQR)	38

Descriptive statistics

Standard deviation	2457.414503
Coefficient of variation (CV)	7.962744666
Kurtosis	621.3112777
Mean	308.6140026
Median Absolute Deviation (MAD)	3
Skewness	21.00267975
Sum	1666207
Variance	6038886.04
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	1987	36.8%
1	381	7.1%
2	240	4.4%
4	155	2.9%
3	147	2.7%
5	114	2.1%
6	95	1.8%
7	79	1.5%
8	69	1.3%
9	58	1.1%
Other values (713)	2074	38.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1987	36.8%
1	381	7.1%
2	240	4.4%
3	147	2.7%
4	155	2.9%
5	114	2.1%
6	95	1.8%
7	79	1.5%
8	69	1.3%
9	58	1.1%

Value	Count	Frequency (%)
98664	1	< 0.1%
54616	1	< 0.1%
47136	1	< 0.1%
44727	1	< 0.1%
42341	1	< 0.1%
40240	1	< 0.1%
38432	1	< 0.1%
30166	1	< 0.1%
27380	1	< 0.1%
25321	1	< 0.1%

min_bank
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	311
Distinct (%)	5.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	32.81718837

Minimum	0
Maximum	12283
Zeros	2880
Zeros (%)	53.3%
Negative	0
Negative (%)	0.0%
Memory size	42.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	2
95-th percentile	105
Maximum	12283
Range	12283
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	263.0925763
Coefficient of variation (CV)	8.016913982
Kurtosis	1042.257159
Mean	32.81718837
Median Absolute Deviation (MAD)	0
Skewness	27.18121113
Sum	177180
Variance	69217.7037
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	2880	53.3%
1	826	15.3%
2	356	6.6%
3	115	2.1%
4	79	1.5%
5	51	0.9%
6	43	0.8%
7	28	0.5%
19	26	0.5%
10	21	0.4%
Other values (301)	974	18.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	2880	53.3%
1	826	15.3%
2	356	6.6%
3	115	2.1%
4	79	1.5%
5	51	0.9%
6	43	0.8%
7	28	0.5%
8	15	0.3%
9	15	0.3%

Value	Count	Frequency (%)
12283	1	< 0.1%
7458	1	< 0.1%
5006	1	< 0.1%
3862	1	< 0.1%
3808	1	< 0.1%
3089	1	< 0.1%
2950	1	< 0.1%
2804	1	< 0.1%
2455	1	< 0.1%
2204	1	< 0.1%

potential_issue
Boolean

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.4 KiB

False	5399

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
False	5399	100.0%

pieces_past_due
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	28
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.7464345249

Minimum	0
Maximum	1134
Zeros	5340
Zeros (%)	98.9%
Negative	0
Negative (%)	0.0%
Memory size	42.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	1134
Range	1134
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	20.74293457
Coefficient of variation (CV)	27.78935577
Kurtosis	1911.300861
Mean	0.7464345249
Median Absolute Deviation (MAD)	0
Skewness	40.59990285
Sum	4030
Variance	430.2693347
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=28)

Value	Count	Frequency (%)
0	5340	98.9%
1	12	0.2%
2	6	0.1%
4	5	0.1%
5	5	0.1%
3	5	0.1%
10	4	0.1%
6	2	< 0.1%
14	1	< 0.1%
1134	1	< 0.1%
Other values (18)	18	0.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5340	98.9%
1	12	0.2%
2	6	0.1%
3	5	0.1%
4	5	0.1%
5	5	0.1%
6	2	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%

Value	Count	Frequency (%)
1134	1	< 0.1%
600	1	< 0.1%
540	1	< 0.1%
430	1	< 0.1%
336	1	< 0.1%
150	1	< 0.1%
144	1	< 0.1%
133	1	< 0.1%
120	1	< 0.1%
80	1	< 0.1%

perf_6_month_avg
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	98
Distinct (%)	1.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-7.861296536

Minimum	-99
Maximum	1
Zeros	128
Zeros (%)	2.4%
Negative	468
Negative (%)	8.7%
Memory size	42.3 KiB

Quantile statistics

Minimum	-99
5-th percentile	-99
Q1	0.63
median	0.82
Q3	0.97
95-th percentile	1
Maximum	1
Range	100
Interquartile range (IQR)	0.34

Descriptive statistics

Standard deviation	28.08100973
Coefficient of variation (CV)	-3.572058324
Kurtosis	6.637265205
Mean	-7.861296536
Median Absolute Deviation (MAD)	0.16
Skewness	-2.938364431
Sum	-42443.14
Variance	788.5431074
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	510	9.4%
-99	468	8.7%
0.99	454	8.4%
0.77	317	5.9%
0.82	288	5.3%
0.98	253	4.7%
0.96	175	3.2%
0.69	162	3.0%
0.97	157	2.9%
0.89	134	2.5%
Other values (88)	2481	46.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-99	468	8.7%
0	128	2.4%
0.02	4	0.1%
0.03	1	< 0.1%
0.04	1	< 0.1%
0.05	5	0.1%
0.06	6	0.1%
0.07	10	0.2%
0.08	9	0.2%
0.09	15	0.3%

Value	Count	Frequency (%)
1	510	9.4%
0.99	454	8.4%
0.98	253	4.7%
0.97	157	2.9%
0.96	175	3.2%
0.95	99	1.8%
0.94	101	1.9%
0.93	122	2.3%
0.92	72	1.3%
0.91	104	1.9%

perf_12_month_avg
Real number (ℝ)

HIGH CORRELATION
ZEROS

Distinct	101
Distinct (%)	1.9%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-7.478770143

Minimum	-99
Maximum	1
Zeros	87
Zeros (%)	1.6%
Negative	447
Negative (%)	8.3%
Memory size	42.3 KiB

Quantile statistics

Minimum	-99
5-th percentile	-99
Q1	0.65
median	0.81
Q3	0.95
95-th percentile	0.99
Maximum	1
Range	100
Interquartile range (IQR)	0.3

Descriptive statistics

Standard deviation	27.50041029
Coefficient of variation (CV)	-3.677130032
Kurtosis	7.175074444
Mean	-7.478770143
Median Absolute Deviation (MAD)	0.14
Skewness	-3.028464027
Sum	-40377.88
Variance	756.2725663
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-99	447	8.3%
0.99	434	8.0%
0.8	338	6.3%
0.98	281	5.2%
0.97	212	3.9%
0.79	202	3.7%
0.68	194	3.6%
0.95	179	3.3%
0.96	155	2.9%
1	148	2.7%
Other values (91)	2809	52.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-99	447	8.3%
0	87	1.6%
0.01	3	0.1%
0.02	8	0.1%
0.03	3	0.1%
0.04	1	< 0.1%
0.05	7	0.1%
0.06	13	0.2%
0.07	4	0.1%
0.08	3	0.1%

Value	Count	Frequency (%)
1	148	2.7%
0.99	434	8.0%
0.98	281	5.2%
0.97	212	3.9%
0.96	155	2.9%
0.95	179	3.3%
0.94	119	2.2%
0.93	104	1.9%
0.92	95	1.8%
0.91	119	2.2%

local_bo_qty
Real number (ℝ_≥0)

HIGH CORRELATION
SKEWED
ZEROS

Distinct	29
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.6210409335

Minimum	0
Maximum	1447
Zeros	5323
Zeros (%)	98.6%
Negative	0
Negative (%)	0.0%
Memory size	42.3 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	1447
Range	1447
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	21.54688766
Coefficient of variation (CV)	34.69479466
Kurtosis	3831.324837
Mean	0.6210409335
Median Absolute Deviation (MAD)	0
Skewness	59.13402525
Sum	3353
Variance	464.2683679
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=29)

Value	Count	Frequency (%)
0	5323	98.6%
1	26	0.5%
3	7	0.1%
2	6	0.1%
6	4	0.1%
7	3	0.1%
4	3	0.1%
60	2	< 0.1%
14	2	< 0.1%
15	2	< 0.1%
Other values (19)	21	0.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5323	98.6%
1	26	0.5%
2	6	0.1%
3	7	0.1%
4	3	0.1%
6	4	0.1%
7	3	0.1%
8	1	< 0.1%
9	1	< 0.1%
10	2	< 0.1%

Value	Count	Frequency (%)
1447	1	< 0.1%
525	1	< 0.1%
236	1	< 0.1%
162	1	< 0.1%
120	1	< 0.1%
105	1	< 0.1%
96	1	< 0.1%
60	2	< 0.1%
56	2	< 0.1%
50	1	< 0.1%

deck_risk
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.4 KiB

False	4088
True	1311

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
False	4088	75.7%
True	1311	24.3%

oe_constraint
Boolean

CONSTANT
HIGH CORRELATION
REJECTED

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.4 KiB

False	5399

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
False	5399	100.0%

ppap_risk
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.4 KiB

False	4750
True	649

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
False	4750	88.0%
True	649	12.0%

stop_auto_buy
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.4 KiB

True	5231
False	168

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
True	5231	96.9%
False	168	3.1%

rev_stop
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.4 KiB

False	5397
True	2

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
False	5397	> 99.9%
True	2	< 0.1%

went_on_backorder
Boolean

HIGH CORRELATION

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	5.4 KiB

False	5348
True	51

Common Values
Category Frequency Plot

Value	Count	Frequency (%)
False	5348	99.1%
True	51	0.9%

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	sku	national_inv	lead_time	forecast_3_month	forecast_6_month	forecast_9_month	sales_9_month	min_bank	potential_issue	perf_6_month_avg	perf_12_month_avg	deck_risk	oe_constraint	ppap_risk	stop_auto_buy	rev_stop	went_on_backorder
0	1026827	0	NaN	0	0	0	0	0	No	-99.00	-99.00	No	No	No	Yes	No	No
1	1043384	2	9.0	0	0	0	0	0	No	0.99	0.99	No	No	No	Yes	No	No
2	1043696	2	NaN	0	0	0	0	0	No	-99.00	-99.00	Yes	No	No	Yes	No	No
3	1043852	7	8.0	0	0	0	0	1	No	0.10	0.13	No	No	No	Yes	No	No
4	1044048	8	NaN	0	0	0	4	2	No	-99.00	-99.00	Yes	No	No	Yes	No	No
5	1044198	13	8.0	0	0	0	0	0	No	0.82	0.87	No	No	No	Yes	No	No
6	1044643	1095	NaN	0	0	0	0	4	No	-99.00	-99.00	Yes	No	No	Yes	No	No
7	1045098	6	2.0	0	0	0	0	0	No	0.00	0.00	Yes	No	Yes	Yes	No	No
8	1045815	140	NaN	15	114	152	0	0	No	-99.00	-99.00	No	No	No	Yes	No	No
9	1045867	4	8.0	0	0	0	0	0	No	0.82	0.87	No	No	No	Yes	No	No

Last rows

	sku	national_inv	lead_time	in_transit_qty	forecast_3_month	forecast_6_month	forecast_9_month	sales_1_month	sales_3_month	sales_6_month	sales_9_month	min_bank	potential_issue	perf_6_month_avg	perf_12_month_avg	local_bo_qty	deck_risk	oe_constraint	ppap_risk	stop_auto_buy	rev_stop	went_on_backorder
5389	1116867	3	8.0	0	0	1	3	0	1	2	2	0	No	0.84	0.90	0	No	No	No	Yes	No	No
5390	1116868	-7	8.0	0	56	96	112	13	30	56	76	0	No	0.97	0.92	7	No	No	No	Yes	No	Yes
5391	1116869	51	8.0	10	46	102	152	16	42	95	160	17	No	0.99	0.86	0	No	No	No	Yes	No	No
5392	1116870	68	8.0	0	175	325	407	51	120	401	588	42	No	0.77	0.82	0	No	No	No	Yes	No	No
5393	1116871	929	8.0	32	1761	3489	5091	593	2026	4134	6579	153	No	0.99	0.98	0	No	No	No	Yes	No	No
5394	1116872	168	2.0	2	0	0	0	16	57	108	184	559	No	0.93	0.95	0	No	No	No	Yes	No	No
5395	1116873	0	2.0	0	14	14	14	0	0	0	0	0	No	0.99	0.98	0	Yes	No	No	Yes	No	No
5396	1116874	5	8.0	0	0	0	0	0	0	0	0	0	No	0.95	0.96	0	No	No	No	Yes	No	No
5397	1116875	18	9.0	0	0	5	10	1	3	7	11	0	No	0.85	0.83	0	No	No	No	Yes	No	No
5398	1116876	6	4.0	0	2	6	8	8	24	39	56	0	No	0.77	0.80	0	No	No	No	Yes	No	No

Overview

Variables

Interactions

Correlations

Spearman's ρ

Pearson's r

Kendall's τ

Cramér's V (φc)

Phik (φk)

Missing values

Sample

First rows

Last rows